IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CompanyInsert')
	BEGIN
		DROP  Procedure  CompanyInsert
	END

GO

CREATE Procedure CompanyInsert
(
	@UserID int
	, @CompanyName varchar(30)
	, @URL varchar(500)
	, @Symbol varchar(8)
	, @Exchange varchar(20)
)
AS

INSERT INTO Companies
(
	UserID
	, CompanyName
	, URL
	, Symbol
	, Exchange
)
VALUES
(
	@UserID
	, @CompanyName
	, @URL
	, @Symbol
	, @Exchange
)

